package com.gydz.gydzbaseframeworkboot.SgsE.domain;

public enum SqlStatements {

    /**
     * isup话单表
     */
    //语句
    BILLEDISUP_TABLENAME_GRC_ISUP_STATEMENTS("grc_isup_statements","select * from grc_isup_"),
    //头
    BILLEDISUP_TABLENAME_GRC_ISUP_HEAD("grc_isup_head","grc_isup_"),

    /**
     * isup信令表
     */
    //语句
    SIGNALINGISUP_TABLENAME_SGS_ISUP_STATEMENTS("sgs_isup_statements","select * from sgs_isup_"),
    //头
    SIGNALINGISUP_TABLENAME_SGS_ISUP_HEAD("sgs_isup_head","sgs_isup_"),

    /**
     * fas话单表
     */
    //语句
    BILLEDISUP_TABLENAME_GRC_FAS_STATEMENTS("grc_fas_statements","select * from grc_fas_"),
    //头
    BILLEDISUP_TABLENAME_GRC_FAS_HEAD("grc_fas_head","grc_fas_"),


    /**
     * fas信令表
     */
    //语句
    SIGNALINGISUP_TABLENAME_SGS_FAS_STATEMENTS("sgs_fas_statements","select * from sgs_fas_"),
    //头
    SIGNALINGISUP_TABLENAME_SGS_FAS_HEAD("sgs_isup_head","sgs_fas_"),



    /**
     * nullAll表
     */
    //语句
    NULLALL_TABLENAME_STATEMENTS("nullall","select * from nullall"),

    /**
     * dpc_opc表
     */
    //表名
    STATIC_TABLENAME_DPC_OPC("dpcopc","dpc_opc"),

    /**
     * short_number 短号码表
     */
    //表名
    STATIC_TABLENAME_SHORT_NUMBER("shortnumber","short_number"),

    /**
     * call_type 呼叫类型表
     */
    //表名
    STATIC_TABLENAME_CALL_TYPE("calltype","call_type"),

    /**
     * asc_number 表
     */
    //表名
    STATIC_TABLENAME_ASC_NUMBER("ascnumber","asc_number"),

    /**
     * function_code 功能码表
     */
    //表名
    STATIC_TABLENAME_FUNCTIONCODE_CODE("functioncode","function_code"),

    /**
     * terminal 终端表
     */
    //表名
    STATIC_TABLENAME_TERMINAL("terminal","terminal"),

    /**
     * interface_id 接口类型表
     */
    //表名
    STATIC_TABLENAME_INTERFACE_ID("interfaceid","interface_id"),

    /**
     * bicc_isup 表
     */
    //表名
    STATIC_TABLENAME_BICC_ISUP("biccisup","bicc_isup"),


    /**
     * trans_mr 表
     */
    //表名
    STATIC_TABLENAME_TRANS_MR("transmr","trans_mr"),

    /**
     * isup_release_the_reason 表  isup释放原因
     */
    //表名
    STATIC_TABLENAME_ISUP_RELEASE_THE_REASON("isupreleasethereason","isup_release_the_reason"),

    /**
     * isup_type  ISUP消息类型
     */
    //表名
    STATIC_TABLENAME_ISUP_TYPE("isuptype","isup_type"),


    /**
     * isup_type  FAS消息类型
     */
    //表名
    STATIC_TABLENAME_FAS_TYPE("fastype","fas_type"),

    /**
     * isup_type  FAS释放原因
     */
    //表名
    STATIC_TABLENAME_FAS_REASON("fasreason","fas_reason"),

    /**
     * isup_type  ISUP消息类型
     */
    //表名
    STATIC_TABLENAME_MTP_TYPE("mtptype","mtp_type");



    private String TableType;    //表类型
    private String sql;    //表头

    private SqlStatements(String TableType, String sql){
        this.TableType=TableType;
        this.sql=sql;
    }

    public String getTableType() {
        return TableType;
    }

    public void setTableType(String tableType) {
        TableType = tableType;
    }

    public String getSql() {
        return sql;
    }

    public void setSql(String sql) {
        this.sql = sql;
    }
}
